Results 1 to 6 of 6

Pearson Form Positioner with Locked Workbook

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    56

    Pearson Form Positioner with Locked Workbook

    I'm using the pearson form positioner, but I am getting errors with my locked workbook.

    ActiveWorkbook.Unprotect propass
    Dim PS As Positions
    PS = PositionForm(Activities, Range("Y17"), 8, -3, cstFhpFormLeftCellRight, cstFvpFormTopCellTop)
    ActiveWorkbook.Protect propass
    It is erroring on the line with PS

    The error is

    Run-time error '1004':
    Unable to set the visible property of the Worksheet class

    I'm unlocking before and after PS. Do I even unlocked within the PositionForm Function, and it still gives that error? Is there somewhere else in this class I need to unlock?
    Last edited by andrew c.; 07-20-2011 at 12:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1