Consulting

Results 1 to 2 of 2

Thread: Project locked Error

  1. #1

    Project locked Error

    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..

  2. #2
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    Probably used in the project properties ScrollArea. Try this command in Immediante window (in VBE):[vba]Workbooks("Name_of_Workbook.xls").Worksheets("Name_of_Sheet").ScrollArea = ""[/vba]
    Artik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •