PDA

View Full Version : Project locked Error



rajagopal
01-05-2009, 07:49 AM
I've an excel file with macros to disable cut, copy, paste function and disable SAVE AS function.
The macros are working fine whereas i cannot scroll down using vertical scroll bar. I can drag down the vertical scroll bar but the cursor is not getting down.

The horizontal scroll bar function is working fine. I attached the error screenshot for your ref.
Please help..

Artik
01-05-2009, 08:10 AM
Probably used in the project properties ScrollArea. Try this command in Immediante window (in VBE):Workbooks("Name_of_Workbook.xls").Worksheets("Name_of_Sheet").ScrollArea = ""
Artik