LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
COM COM is offline
external usenet poster
 
Posts: 40
Default Disabling Selection of multiple worksheets

I have not been able to find anything that would allow me
to prevent Excel spreadsheet users from selecting multiple
worksheets in a given workbook.

Problem I'm trying to solve is this, though it can be
summed up differently, Users use a workbook that has
multiple worksheets in it. As is commonly known to Excel
users, if multiple worksheets are selected, then data is
changed on any of those multiple sheets the same data is
applied to all selected worksheets. I want to be able to
prevent the selection of multiple worksheets in the first
place. I have figured out that if multiple sheets are
already highlighted/selected, then any other non-active
worksheet is selected, to make that new active worksheet
the only selected sheet. However, I have not figured out
how to prevent a user from first selecting a worksheet
then say holding the shift key selecting a worksheet
several tabs over, and then editing data on the active
sheet which would then change the data of all the selected
sheets.

If anyone knows how to prevent the selection of multiple
worksheets from the get go, I wouldn't need so much user
error correction/prevention.

Thanks
 
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
multiple selection AND Excel Discussion (Misc queries) 9 February 13th 09 07:40 PM
multiple selection copy & paste across multi-worksheets aw Excel Discussion (Misc queries) 0 November 29th 07 06:20 AM
Hiding worksheets based on user selection HL Excel Worksheet Functions 3 October 12th 06 04:01 PM
Excel should have unhide all worksheets selection or button. JMayers97 Excel Worksheet Functions 1 April 19th 06 05:07 AM
Disabling protected cell selection sneakyzeal Excel Worksheet Functions 1 September 9th 05 05:24 PM


All times are GMT +1. The time now is 05:26 PM.

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"