I have a spreadsheet where I'm inserting 3 command buttons, one on 3 different sheets.
The command buttons will reset the entered data once the reopen the workbook
I ran into a problem on the 2nd sheet, everything works fine on the 1st sheet
Sheet 1 is called Operator
Sheet 2 is called Forklift Operator
Sheet 3 is called Maintenance
I'm using a command button because my knowledge of macros/vba is weak and I couldn't figure out how to code it to reset the workbook after closing.
I tried to attach a photo but it failed, it was only 8mb
Instead, here's a quick example from the excel spreadsheet...
In the left column, under VBA Project (Daily Work Sheet.xlsm)
Microsoft Excel Objects
Sheet 1 (Operator)
Daily Work Sheet.xlsm - Sheet1 (Code)
Reset and Click
Private Sub Reset_Click()
then the coding
Sheet 2 (Forklift Operator)
Daily Work Sheet.xlsm - Sheet2 (Code)
General and Reset_Click
Private Sub Reset_Click()
then the coding
Note: I'm unable to change the Reset and Click and the General and Reset_Click
Sheet 1 works perfectly, Sheet 2 generates a message that says The Macro may not be available in this workbook
If you have any ideas, let me know
Thanks
Brian
Bookmarks