Macros don't work in password protected file.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macros don't work in password protected file.

FAQ

Thread Tools

Display Modes

06-28-2016, 12:47 PM

WRowan

Windows XP Macros don't work in password protected file.

Office 2010 32bit

Novice

Join Date: Jun 2012

Posts: 4

I have such a file. Are you un-protecting the file before trying to run the macro? Otherwise Excel sees running the macro as an attempt to change a pw-protected file and balks at running it.

I type in the pw each time I want to run the macro. Usually I'm not making changes to this file so I just close without saving, which saves the hassle of re-protecting.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to restore identification of password protected excel file	da.mage	Excel	0	01-04-2016 06:21 AM
Vb script to open a password protected project 2003 file	virencm	Project	1	04-03-2014 08:02 AM
Password protected file no longer offers password dialog on Open	htaylor	Word	0	10-15-2013 12:35 PM
Oops password protected word !!!	mistermouse	Word	5	02-16-2011 01:56 PM
Password Protected Files	gurp99	Word	0	08-17-2010 03:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 PM.