Thread
:
Macro does not work after the program has been restarted in excel.Run time error 2147417848 (80010108) Method visible of object_worksheet failed
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 789
Macro does not work after the program has been restarted in excel.Run time error 2147417848 (80010108) Method visible of object_worksheet failed
Hi
Is the workbook protected? If it is, you will have to remove protection
before making the sheets hidden or visible (as you are changing the
workbook).
regards
Paul
wrote:
I have a serious problem which i can not solve. I have buildt a simple
password login macro in excel making it possible to give different
users different information.
The macro works fine when I made it, however After I save it and
restart it again the above message pops up, when I start the Macro.
the macro I have made look like this,
I seems like the macro crash on this line ( Sheets(i).Visible =
xlSheetVeryHidden)
...
Thank you in advance
Brgds
Knut
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]