1) Excel workbook with over 50 worksheets.
2) Numerous copies of worksheets were made during creation of workbook.
3) Main Menu only worksheet that should be showing when file is open with hyperlinks to each worksheet which unhides the worksheet.
4) Each worksheet has hyperlink back to Main Menu and code to hide the worksheet when returning to Main Menu.
5) Did work fine on my computer, but not on other people's computers.
6) Found that an Active X to my Avaya (phone) online messages was the issue.
7) Unchecked this on my computer (ALT F11, Tools, References, unchecked box)
8) File worked for a colleague yesterday after completing #7.
9) Today I get the error below when I opened the file.
Run-time error '1004'
Unable to set the Visible property of the Worksheet class
Goal of workbook is to have all worksheets hidden and unhidden when link is clicked on the Main Menu. Need to send out to many people inside and outside of the company so differeing versions of Excel will be encounterred. Need workbook protected and only some cells unlocked for user's entry of information. File is quite large. VBA code used on some worksheets to reset unlocked cells. One sheet has hyperlinks to other worksheets and a button to hide rows that contain a 1 and unhide these rows.
2) Numerous copies of worksheets were made during creation of workbook.
3) Main Menu only worksheet that should be showing when file is open with hyperlinks to each worksheet which unhides the worksheet.
4) Each worksheet has hyperlink back to Main Menu and code to hide the worksheet when returning to Main Menu.
5) Did work fine on my computer, but not on other people's computers.
6) Found that an Active X to my Avaya (phone) online messages was the issue.
7) Unchecked this on my computer (ALT F11, Tools, References, unchecked box)
8) File worked for a colleague yesterday after completing #7.
9) Today I get the error below when I opened the file.
Run-time error '1004'
Unable to set the Visible property of the Worksheet class
Goal of workbook is to have all worksheets hidden and unhidden when link is clicked on the Main Menu. Need to send out to many people inside and outside of the company so differeing versions of Excel will be encounterred. Need workbook protected and only some cells unlocked for user's entry of information. File is quite large. VBA code used on some worksheets to reset unlocked cells. One sheet has hyperlinks to other worksheets and a button to hide rows that contain a 1 and unhide these rows.
Last edited: