Permanently hide worksheet from user using VBA?
Here is the simple code to Hide and unhide Worksheet: Sub Hide_Unhide_Worksheets() Dim oWS As Worksheet On Error GoTo Err_Filter oWS = Worksheets(1) ‘ hide the sheet – user cannot… Read more »
Monthly Archives: March 2015
Create a sheet multiple times and rename it to a given name using VBA
You may have template sheet which you need to copy multiple times and rename these sheets according to the list (maybe on another sheet). Suppose you have a sheet named… Read more »