View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Davies Tim Davies is offline
external usenet poster
 
Posts: 2
Default Scroll Area Problem

I have a problem in that I set a scroll area on a sheet in VBA, press the
save button in VBA, and then return to my worksheet, test the scroll area,
and it works perfectly. I then save the workbook, and close it. When I open
it again, it asks me wether I want to enable macros, so I do enable them, but
find that the scrool limits have dissapeared in VBA, and do not work in the
sheet.
Can anyone help/explain what I'm doing wrong?

Tim