Buttons to Hide/Unhide Columns - Speed Up?

[maddog9486]

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:

Please Login or Register  to view this content.

Thanks.

[Izandol]

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.

[maddog9486]

Thanks Izandol. Your suggest was correct. Everything is instant now.