Hi all! I have a workbook (xlsm form), that is saved (as xlsx format) and distributed. The file name is auto-generated based on cells on a specific worksheet "Main". This sheet needs to be deleted, and then there are 3 sheets hidden (2 of which are extra hidden). I modified a previous macro for these needs, but ran into an error on the way. The error I get is a compile error (see screenshot). Now I am confused as I have used this snippet of code before without any issues. Attached is the code for viewing and my sample workbook.
In a nutshell:
sheet7 ("Main")is the Control Panel, and deleted, this sheet is the leftmost tab
Sheet1 ("data")hidden
Sheet8 ("calcs")extra hidden
Sheet3 ("codes")extra hidden
Bookmarks