Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 590
Default protect Micro

I won't to protect a macro so it can't be changed.
thank
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default protect Micro

Hi Ken,

In the VBE,

Tools | VBAProperties | Protection | Lock Project For Viewing |
Insert password | OK

Now, save, close and re-open the file.

Note, however, that Excel security is very weak and may readily be
surmounted,



---
Regards,
Norman


"Ken" wrote in message
...
I won't to protect a macro so it can't be changed.
thank



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
Micro Ganesh Kumar Excel Worksheet Functions 2 July 21st 09 03:54 PM
Micro or Function??? Diana Excel Discussion (Misc queries) 2 February 20th 07 08:49 PM
Micro roheel Excel Programming 0 April 26th 05 09:43 AM
Micro djmimi Excel Worksheet Functions 0 February 9th 05 05:29 PM
what does the micro do Ibrahim New Users to Excel 1 December 8th 04 01:54 PM


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