Buttons to Hide/Unhide Columns - Speed Up?
I have a worksheet with some buttons to Hide and Unhide various columns. Everything in my current sheet works fine, but I was trying to find out if there is a way to speed it up some (there is currently a slight delay (not a major problem).
Example of 3 button codes:
Thanks.
Please Login or Register to view this content.
Last edited by maddog9486; 11-25-2013 at 10:02 AM.
I think the delay is from the protection. Perhaps you may protect the worksheets when the workbook opens using the UserInterfaceOnly:=true argument and then you do not need to change the protection to hide or unhide the columns.
Thanks Izandol. Your suggest was correct. Everything is instant now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks