Erorr from this code

[Kavy]

Hello, this gives me an error, anyone know why?

Range("A" & rowf).Font.Size = 12

rowf = 10 at this point.

Error is that is says it cannot set the size property

 

[Jonmo1]

Only reason I could think of is if the sheet is protected.

If so, you can unprotect the sheet - do stuff - reprotect the sheet

activesheet.unprotect "Password"
Range("A" & rowf).Font.Size = 12
activesheet.protect "Password

If that's not the problem, We'll probably need to see the rest of the code to figure out what's wrong.

 

[Kavy]

i have protected the whole workbook not the sheets by them self, would that do it?

 

[Kavy]

scracth that, not true, only one sheet is protected and its not that
The sheet is set to veryhidden though/...?

 

[VoG]

Perhaps

Application.ScreenUpdating = False
Sheets("Sheet1").Hidden = False
Sheets("Sheet1").Range("A" & rowf).Font.Size = 12
Sheets("Sheet1").Hidden = xlVeryHidden
Application.ScreenUpdating = true

 

[Jonmo1]

sheet hidden will not effect it.

Are you sure protection is not the issue?

Try putting the Unprotect code just before the line that is failing..

 

[Norie]

Kavy

Why would you want to change the font size in a sheet that isn't visible?

By the way I tested the code on a very hidden worksheet and it appeared to work.

Mind you I did include a worksheet reference.

 

[Jonmo1]

Why would you want to change the font size in a sheet that isn't visible?

Ahhh, That is a good question.

But, I think it's time for you to post the whole code Kavy.

 

[Kavy]

sorry guys now its not happing, I can't re-produce it.
I did use the unprotect thing and it did stop around then but it was after the error ...

Sorry to waste you time, i have no idea what happen!
Its a form being printed, thats why I am changing the font of a hiddensheet
(I unhide right b4 printing and hide after)