Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Protecting a VBA project

Hi Bob,
Thanks for your input but I've tried that already.It generates an
error when I myself try to open the code the next time.Even I am not
able to view the code after I set the password once.Any suggestions
would be most welcome.

Thanks,
Ekta.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Protecting a VBA project

Are you sure you're typing in the correct password--check your capslock key.

Do you edit the code in different versions of excel. Excel 2k and 2002 have a
stronger protection scheme. If you protect the code in xl2k or xl2002, then
xl97 can't open them--it can run them, but you can't view them (or change them).

And if you've shared the workbook, you can't edit the macros, either.

Ekta Singh wrote:

Hi Bob,
Thanks for your input but I've tried that already.It generates an
error when I myself try to open the code the next time.Even I am not
able to view the code after I set the password once.Any suggestions
would be most welcome.

Thanks,
Ekta.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


--

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
protecting formulas without protecting sheet so grouping still wor JM Excel Discussion (Misc queries) 1 June 4th 09 06:42 AM
Excell error "Can't find Project or Library" Project VBAProject Lost in Excel Excel Worksheet Functions 0 April 12th 07 04:42 PM
project jorge Excel Worksheet Functions 0 March 28th 07 07:28 PM
How to convert MS Project to MS Excel. I don't have MS Project. Jane Excel Discussion (Misc queries) 1 February 20th 06 11:01 PM
Protecting a VBA project Bob Phillips[_5_] Excel Programming 0 July 9th 03 07:24 AM


All times are GMT +1. The time now is 09:20 PM.

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"