Windows Forum

Ask something
Discussion Locked

Excel Hidden Macros

0 helpful
7 replies

by meares

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Excel spreadsheet that has a macro that saves the spreadsheet in a "csv" format using a different extention. I need to change this but when it was original built the Macros were either protected or hidden and now I can't view them in order to change them. Can someone tell me how I can unhide or unprotect them.

Thanks for the help. It's truly appreciated.

7 replies

by j.wallace

Hi - you don't say what version of Excel you have, but I'll take a shot. (Here, I've got Excel 97 running on NT 4).

You do realize that editing a macro means having to work in Visual Basic (*ugh*)...?

Is the worksheet protected? If not, can you record a new macro in the file?

If that's all the macro did, I'd copy the worksheet contents to a new file and record the macro there.

Please post more details if this isn't enough to help.

- Rick -

by meares

My Excel did not show that it was protected. But when going to Macros to modify the VB it was protected and not showing. Thanks for you your help it made since and I'll test it on another excel I have but I still don't know how to retreive the one I'm trying to work on.

by nselph

Its possible that if you are using Excel from Office 95, that the macro sheet has the property
xlVeryHidden. In that case you need to find out the macro sheet's name and write another macro that changes the property to Visible.
Sheets("Whatever").Visible = True

Or else I think you can set all Sheets to Visible.
Sheets.Visible = True

Otherwise, if you go to a higher version of Excel, at least 97, you should be able to see the sheet if you go to the Visual Basic editor as the previous poster described.

If the entire workbook is password protected, and you don't have the password, you may be in trouble.

This discussion is closed to new replies.