Thread: Code to display dialog for unhiding sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
  
Posts: 811
Default 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 *


Reply With QuoteReply With Quote