macro to unhide a sheet
I've found a great macro on this forum to unhide a hidden sheet:
Sub Button12_Click() Sheets("C H M").Visible = True Sheets("C H M").Activate End Sub My concern is I will have to paste this button on a large and constantly growing number of sheets that our clerks will use. Is there a way I could add this command to the actual menu at the top of the screen so it can always be in one spot for the clerk and not a button pasted on hundreds of sheets? |
macro to unhide a sheet
You can save your workbook with the macros as an addin (*.xla). The provide the
user someway of running those macros. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Bill_S wrote: I've found a great macro on this forum to unhide a hidden sheet: Sub Button12_Click() Sheets("C H M").Visible = True Sheets("C H M").Activate End Sub My concern is I will have to paste this button on a large and constantly growing number of sheets that our clerks will use. Is there a way I could add this command to the actual menu at the top of the screen so it can always be in one spot for the clerk and not a button pasted on hundreds of sheets? -- Dave Peterson |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com