Unhide command?

cables · May 4th, 2002, 11:07 PM

Hi,
I can "Step Into" my macros, but cannot "Edit" them. I get a message: "Cannot edit a macro on a hidden workbook. Unhide the workbook using the unhide command". The help menu doesn't say anything about the Unhide Command.
What does hidden mean and how can I unhide it?
Thanks.
Ron S

Anne Troy · May 4th, 2002, 11:10 PM

From your Window menu in Excel (not the VB Editor), choose Unhide.

Nimrod · May 4th, 2002, 11:10 PM

On your toolbar , on the window menu, there is a hide and unhide command . Check the unhide command and see if you have a hidden workbook if you do unhide it with the unhide command.

cables · May 5th, 2002, 07:30 AM

Quote:

On 2002-05-04 22:10, Dreamboat wrote:
From your Window menu in Excel (not the VB Editor), choose Unhide.

Hi Dreamboat,
Thank you for your reply. I chose Unhide but now all my macros are gone. What gives? I would like to be able to print a macro but can't from Step Into.
Cables

Anne Troy · May 5th, 2002, 01:17 PM

Cables, are you familiar with the VB Editor window?

At the top-left you'll see a *browsing* window that's a lot like Windows Explorer. On the *first level*, you should see your file, and also any hidden files that you've *unhidden* by going to Window menu in the Excel workbook view and choosing Unhide.

If you are not familiar with hidden Excel files, and you're doing VBA, then you should be.

When you create a macro to be used in ALL files, Excel automatically creates a file called personal.xls. This file is stored in your XLSTART directory. It is also hidden. Other than that, it's an Excel file like any other.

Launch Excel with NO files open. Hit Window on the menu. Hit Unhide. Are you given any file names? At this point, it seems this would be your first step.

May 4th, 2002, 11:10 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	From your Window menu in Excel (not the VB Editor), choose Unhide. __________________ ~Anne Troy

May 5th, 2002, 01:17 PM	#5
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Cables, are you familiar with the VB Editor window? At the top-left you'll see a browsing window that's a lot like Windows Explorer. On the first level, you should see your file, and also any hidden files that you've unhidden by going to Window menu in the Excel workbook view and choosing Unhide. If you are not familiar with hidden Excel files, and you're doing VBA, then you should be. When you create a macro to be used in ALL files, Excel automatically creates a file called personal.xls. This file is stored in your XLSTART directory. It is also hidden. Other than that, it's an Excel file like any other. Launch Excel with NO files open. Hit Window on the menu. Hit Unhide. Are you given any file names? At this point, it seems this would be your first step. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 4th, 2002, 11:07 PM	#1
cables New Member Join Date: Apr 2002 Posts: 4	Hi, I can "Step Into" my macros, but cannot "Edit" them. I get a message: "Cannot edit a macro on a hidden workbook. Unhide the workbook using the unhide command". The help menu doesn't say anything about the Unhide Command. What does hidden mean and how can I unhide it? Thanks. Ron S

May 4th, 2002, 11:10 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	On your toolbar , on the window menu, there is a hide and unhide command . Check the unhide command and see if you have a hidden workbook if you do unhide it with the unhide command.