Billa7
asked on
Hide Sheet
Hi,
Intent to hide "Menu" sheet in the attached workbook, and the sheet only open when click "Open Sheet Button". The sheet back to hidden when user click "Data' Sheet. Hope Expert could help create this macro. Attached the workbook.
HideSheet.xls
Intent to hide "Menu" sheet in the attached workbook, and the sheet only open when click "Open Sheet Button". The sheet back to hidden when user click "Data' Sheet. Hope Expert could help create this macro. Attached the workbook.
HideSheet.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just right click the picture and hit "Assign Macro" and select that macro that hisdoshi1 provided.
Dave
Dave
ASKER
Hi Dave,
I've tried, but it shows an error message "the item with the specified name was not found" at this line:
Sheets("Data").Shapes("But ton 1").Select
I've tried, but it shows an error message "the item with the specified name was not found" at this line:
Sheets("Data").Shapes("But
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks a lot for the help
Thanks a lot for the help
ASKER
Need help. How to modify the code if I replace the button with picture (e.g. Picture 8)?