Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Unprotect method run-time error

I should have been more specific. The code works fine with
XL2K on a Win98 or WinNT machine, but does not work using
XL97 on a Win98 or WinNT machine. I had the "verified
password" in the post to indicate that I was using the
write password, it's not part of the code.

Rohit
-----Original Message-----
Hi Rohit,
I'm using NT4 with Xl2k at work, and the below code works
fine. I'm assuming you dont have the "(verified

password)"
in the coding. If you do, you may want to remove it or

put
a ' in front of it to comment it out.

HTH's.

-----Original Message-----
Hello All,

I have code that I wrote in XL97 that works fine when I
run it on a Win 2K pc but fails on a Win 98 or WinNT 4.0
pc. Here's the line of code which fails and the

associated
run-time error. The code is executed from a button on a
userform.

Private Sub ImportPPSPayrollFile()
***some code here***
ActiveSheet.Unprotect Password:="ppsproofpay"(verifed
password)
***some code here***
End Sub

Run-time error '1004' - Unprotect method of Worksheet
class failed.

Any thoughts on why this might be happenning??

Thanks in advance,
Rohit Thomas
.

.

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
Run-time error '1004': AutoFill method of Range class failed murkaboris Excel Discussion (Misc queries) 10 April 16th 09 09:06 PM
Run-time error '1004': AutoFill method of Range class failed murkaboris Excel Discussion (Misc queries) 3 April 14th 09 10:35 PM
Run-Time error '1004' : Select method of Range class failed [email protected] Excel Discussion (Misc queries) 3 March 9th 07 02:36 PM
Run-time error "1004" Select method of range class failed Tallan Excel Discussion (Misc queries) 3 March 7th 07 06:22 PM
Dynamic chart generation: Run time Error '1004: Method 'Cells' of object'_Global' fai Ajay_N Charts and Charting in Excel 1 August 15th 06 03:54 AM


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