Hiding a column issue

[warehouseman]

I have a workbook that opens to a certain sheet and the form opens perfectly when the workbook opens. But when i use the macor to reopen the form using this sub it hangs up. It will not hide column "F". The problem is in the highlighted red line. Thanks for you input and help

Sub OpenUserForm()

ActiveWorkbook.Sheets("VILLAGEvisits").Activate
Columns("F").Hidden = True
FrmVillageVisits.Show

End Sub

[haripopuri]

Is the sheet protected?

[warehouseman]

Yes the sheet is protected. I think you may be pointing me in that direction as the problem. The first row must never be changed - it contains headers that match an Access DB so it can import the sheet. So to prevent users from potentially changing it I protected the sheet.

[haripopuri]

When you protect a sheet and try to hide a column without first unprotecting it, it will throw up error.

[Blokeman]

Try;

Please Login or Register  to view this content.

[warehouseman]

Yes, that took care of the issue. I never realized protecting would cause a problem like that. Thank you so very much for your help.