Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to display dialog for unhiding sheets
"ken" wrote in message
... How can I use code to display the dialog one sees on using the menu Format/Sheet/Unhide? Application.Dialogs (xlDialogUnhide).Show gives me hidden workbooks. Hi Ken, Someone at MS got these constants mixed up in the object model. Use xlDialogWorkbookUnhide to show the Unhide Sheet dialog and xlDialogUnhide to show the unhide workbook dialog. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to display dialog for unhiding sheets
Thank you. I thought it was rather counterintuitive.
-----Original Message----- "ken" wrote in message ... How can I use code to display the dialog one sees on using the menu Format/Sheet/Unhide? Application.Dialogs (xlDialogUnhide).Show gives me hidden workbooks. Hi Ken, Someone at MS got these constants mixed up in the object model. Use xlDialogWorkbookUnhide to show the Unhide Sheet dialog and xlDialogUnhide to show the unhide workbook dialog. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding / Unhiding Sheets | Excel Discussion (Misc queries) | |||
Unhiding Sheets | Excel Worksheet Functions | |||
need code for hiding/unhiding sheets using checkboxes | Excel Worksheet Functions | |||
Unhiding All hidden Worksheets with a Macro/VBA Code | Excel Discussion (Misc queries) | |||
Unhiding Sheets | Excel Discussion (Misc queries) |