Excel 4.0 Macro

**floydbird** · 02-19-2008, 01:41 PM

What O/S are you running? To which level have you set security?

**shg** · 02-19-2008, 02:02 PM

The macro could be on a hidden sheet, or could be used in a named formula.

To check for the former, open the VBE and see if there are any sheets that don't show up with tabs in the workbook (Hidden or VeryHidden).

For the latter, do Insert > Name > Define, and look at all the names.

**Mary Frances** · 02-19-2008, 05:01 PM

Originally Posted by shg

The macro could be on a hidden sheet, or could be used in a named formula.

To check for the former, open the VBE and see if there are any sheets that don't show up with tabs in the workbook (Hidden or VeryHidden).

For the latter, do Insert > Name > Define, and look at all the names.

I have un-hidden all of the sheets, and there are no macros show up that were not there before. What is a VeryHidden Sheet?

Also, there is only one "Name" that shows up, and that is for a conditional formatting I created recently (in Excel 2003).

Any other suggestions? I am at a loss.

**shg** · 02-19-2008, 05:47 PM

VeryHidden is an attribute that keeps sheets from being seen when you do Format > Sheet > Unhide. You can open the VBE (Alt+F11), open the Project Explorer window within it (Ctrl+R), and verfy that all the sheets listed appear in the workbook.

**Mary Frances** · 02-20-2008, 12:00 PM

Originally Posted by shg

VeryHidden is an attribute that keeps sheets from being seen when you do Format > Sheet > Unhide. You can open the VBE (Alt+F11), open the Project Explorer window within it (Ctrl+R), and verfy that all the sheets listed appear in the workbook.

Yes, all of the sheets are accounted for. There are no very hidden sheets in the workbook. Is there a place to locate macros in a workbook except for Tools-Macros.

Could I have copied some information from a previous version of the workbook that brought along an old macro?

Any suggestions would be appreciated.

**shg** · 02-20-2008, 12:41 PM

Mary Frances, I have no other suggestions. VBA Noob has a very good grasp of XLM macros; perhaps he'll stop buy.

**VBA Noob** · 02-20-2008, 01:19 PM

Shg,

I've only really come across Excel 4.0 macros from Walkenbach and chip site's. I've use it in the past to highlight formulas

http://www.j-walk.com/ss/excel/usertips/tip045.htm

http://www.cpearson.com/excel/Call.htm

Maybe you could see if you have a named range refering to the GET.CELL Excel 4.0 macro or upload the file

Another option is to copy the sheets to a new workbook
http://www.j-walk.com/ss/excel/tips/tip58.htm

Here are a few other sites

http://support.microsoft.com/default...S;Q128185&FR=1

http://www.mrexcel.com/archive2/18800/21312.htm

VBA Noob