Hi all,
I recently posted a similar issue to this but did not receive a workable solution.
So I am hoping a second different post may locate someone to fix please.
The attached Sheet works fine without Password protection
But when I protect, I get the dreaded
1004 Run-Time Error - Unable to set the Name property of the Font Class.
Debug points to the code line Target.Font.Name = "Arial"
Screen pics are pasted into the attached sheet.
A solution would be appreciated please.
Change the password to suit.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks