LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
GA
 
Posts: n/a
Default Include a password in VB code.

Can anyone help please.

I have a workbook that records overtime and the code behind a button on
the sheet is used to start a new 28 day period. It unprotects the sheet,
stores the carried forward amount, clears all the entries, enters new
dates and pastes in the stored carry forward amount and finally
re-protects the sheet. It all works fine except that many of our users
make a habit of unprotecting the sheet and entering values over the top of
functions and then complain next month that the workbook is broken!

I want to password protect the sheet but that breaks my code.

Is there a way to include a password in the VB code?

TIA - GA

 
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
Very Novice Excel user with security question Ralph Malph Excel Discussion (Misc queries) 5 March 23rd 06 06:33 PM
Worksheet Protection Angeline Excel Discussion (Misc queries) 3 March 20th 06 12:49 PM
VLOOKUP for Zip Code Ranges JerseyJR Excel Worksheet Functions 2 September 6th 05 06:37 PM
Using other workbooks.. DavidMunday Excel Worksheet Functions 2 July 1st 05 07:35 AM
password protect vba code greg Excel Discussion (Misc queries) 3 December 8th 04 04:03 PM


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