LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JD2 JD2 is offline
external usenet poster
 
Posts: 9
Default Protect a shared workbook

Dear Excel Gurus,

One of my colleagues has an Excel spreadsheet which is shared amongst
several users (who need to use it simultaneously). On one of the sheets, he
wishes to protect the first two columns of four columns so they can view the
information but not change it. They need to be able to put their name in the
fourth column though and use the first two columns to reference it so they
put it in the right place.

I understand that protecting a shared workbook in Excel 2003 is not
possible. Does anyone know a workaround this? Has anyone perhaps written
some VBA to get around it?

Would appreciate any suggestions you have.

Kind regards
JD2
 
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
Protect shared workbook ub Excel Worksheet Functions 4 March 18th 09 03:10 PM
how can I protect entries in a shared workbook? Stamatis Excel Discussion (Misc queries) 0 October 24th 06 09:57 AM
Can I unprotect / protect a shared workbook? Florence Excel Programming 8 August 17th 05 04:08 PM
Protect UserInterfaceOnly in Shared Workbook Christopher Gardner Excel Programming 0 August 21st 03 09:43 PM
Protect UserInterfaceOnly in Shared Workbook Christopher Gardner Excel Programming 0 August 21st 03 09:43 PM


All times are GMT +1. The time now is 05:42 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"