Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vv
 
Posts: n/a
Default password protected certain cells in spreadsheet

Hi folks,

can I use password protect some cells and use another password protect some
other cells within the same workbook?? using vba/marco??

Thnaks
VV
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

If I understand correctly, you can have different passwords for different
worksheets, but not different passwords for different cells on a single sheet.

On Tue, 8 Feb 2005 18:23:03 -0800, "vv" wrote:

Hi folks,

can I use password protect some cells and use another password protect some
other cells within the same workbook?? using vba/marco??

Thnaks
VV


  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

xl2002 added this level of granularity.

Myrna Larson wrote:

If I understand correctly, you can have different passwords for different
worksheets, but not different passwords for different cells on a single sheet.

On Tue, 8 Feb 2005 18:23:03 -0800, "vv" wrote:

Hi folks,

can I use password protect some cells and use another password protect some
other cells within the same workbook?? using vba/marco??

Thnaks
VV


--

Dave Peterson
Reply
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
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 12:37 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM
How do I password protect cells in a spreadsheet created in Excel Tbenson37303 Excel Worksheet Functions 0 November 22nd 04 09:21 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 09:21 PM


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