LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default disable sheet while processing

I have a sort sub() that takes some time to complete. Running it
requires that I remove protection for the sheet, unhide rows and blah
blah.

Is there anyway to keep a user's hands off the workbook while this
runs? My impression is that the mouse is on one leg while all this
happens, but I'm not sure just what it can get away with. Que up
clicks and make a mess? This sheet is so busy I'd keep it all locked
up if I could.

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable View Code for Sheet? Lostguy Excel Programming 1 February 22nd 09 10:13 PM
disable tab function on sheet tab johnny Excel Discussion (Misc queries) 4 April 19th 08 04:27 PM
Auto Disable Macros on new sheet DDub207 Excel Programming 5 July 31st 07 01:54 PM
Disable sheet copy/move Casper[_2_] Excel Programming 5 March 3rd 06 05:23 PM
Processing code on wrong sheet Jeff Klein Excel Programming 1 January 3rd 05 06:38 PM


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"