I am trying to hide an 2nd open workbook with this VBA code:
It results with an "Object doesn't support this property or method." error.
Please Login or Register to view this content.
Adjustng the code to this gives the same error ...
Please Login or Register to view this content.
Hello Jenn68,
Please see Here.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
It's Windows(1), not Window(1).
Rory
mistakenly posted.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thank you again Rory.
What is the purpose of "windows(1)" in comparison to the the solution posted by Winon in which it is excluded. In that case workbookname.visible=false seems adequate (although didn't work in my case).
Posted in error
Last edited by Jenn68; 03-12-2019 at 03:29 PM.
That code loops through the Windows, so it's basically the same method you are using, except it does all inactive workbooks.
@ rorya,
Well spotted Rorya, I missed that.
@ Jenn68,
Glad to see your issue had been resolved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks