Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Problem with Workbook Protection Excel 2007

Hi,

I have the following code in a module:
Sub ProtectWorkbook()
ThisWorkbook.Protect Structu=True, Windows:=False, password:="xxxx"
End Sub

When I run this, the workbook remains unprotected. I am using Excel
2007. Am I doing anything wrong?

(I tried running through the code using F8. It runs but the workbook
remains unprotected).

Thanks in advance for the help.

Regards,
Raj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel 2007 sheet and workbook protection	Old Keith	Excel Worksheet Functions	8	January 16th 17 07:15 AM
How secure is Excel 2007 worksheet protection?	Greg Lovern	Excel Discussion (Misc queries)	3	January 16th 17 07:02 AM
Password protection not working in Excel 2007	kcmcauley	Setting up and Configuration of Excel	0	July 23rd 09 11:18 PM
Excel File Protection 2003 vs. 2007	curious_rosebud	Excel Discussion (Misc queries)	0	February 18th 09 10:15 PM
Excel 2007 workbook problem	Mary C[_3_]	Excel Discussion (Misc queries)	2	April 25th 08 07:46 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us