+ Reply to Thread
Results 1 to 2 of 2

Do Userforms in a Shared Workbooks Close Differently than Unshared?

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Do Userforms in a Shared Workbooks Close Differently than Unshared?

    The users of a project I'm updating routinely have the main worksheet zoomed down to 75% in order to see all of the necessary columns on the screen at once. In order to avoid the "Not enough resources to display completely", I change the zoom to 100% while the userform is open, saving the previous zoom setting as a variable and restoring it once the userform is closed.

    In Userform_Activate:
    Please Login or Register  to view this content.
    In Userform_QueryClose
    Please Login or Register  to view this content.
    This works fine until I share the workbook, at which time it stops resetting the zoom level when the form is closed. I've experimented with a button to change the zoom settings while the userform is open and that works fine, so I know it's possible to change the zoom programmatically within a shared workbook, so what would stop the last line of code from resetting the zoom when the form is closed in a shared workbook?

    Two random bits of possibly useful information: ZoomValue is declared as a Public Integer (in a separate module) and I also tried moving the code from Userform_QueryClose to Userform_Deactivate but it made no difference.
    Last edited by Samuel K; 03-05-2012 at 05:10 PM. Reason: Marking as Solved

  2. #2
    Registered User
    Join Date
    01-20-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Do Userforms in a Shared Workbooks Close Differently than Unshared?

    While I'm not entirely sure why this was working in an unshared workbook but failing when the workbook was shared, I did manage to fix the problem. Although what was displayed on the screen was never changed, the userform did interact with multiple workbooks and sheets. I had to set the original sheet as active and then the zoom started working again.

+ Reply to Thread

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