LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Locking Pages and/or Workbook

Hello, Everyone!

I hope this is the appropriate area to post this. If not, please forgive.

I have an Excel 2010 workbook I want to share with others. It is full of data (all text or just numbers, but no numeric calculations) and hyperlinks to either other sheets in the same workbook or hyperlinks to PDF files I keep in a subdirectory off my C:\ drive.

What I want to be able to do is allow others to see the data, move from sheet to sheet, hyperlink to the PDFs and see those, etc. but NOT alter any data or hyperlinks (no changing, adding, deleting, etc.).

It seems to me that protecting the workbook isn't the function I want, and there is no way to protect all sheets in one motion (I would have to individually protect every sheet, and there are LOTS). This becomes a bigger task since I would need to unprotect everything and make additions or changes frequently, and then re-protect everything to make it safe for others to use again. (I hope this makes sense.)

ANY help, suggestions or prayers appreciated!

Andrew....
 
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
Locking specific cells in a workbook Sarah Excel Discussion (Misc queries) 2 April 17th 07 03:16 AM
Locking a linked workbook jennajay Excel Programming 0 November 10th 06 09:08 PM
Locking a Workbook Patrick Simonds Excel Programming 1 October 3rd 05 04:04 PM
Locking project with workbook open? Joe90[_2_] Excel Programming 3 November 7th 04 10:30 PM
Locking and unlocking a workbook Nigel Bennett Excel Programming 1 June 21st 04 03:58 PM


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

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

About Us

"It's about Microsoft Excel"