Results 1 to 3 of 3

Thread: [RESOLVED] How to unlock the sheets while the form is opened?

  1. Jan 12th, 2011, 08:23 AM #1
    marlonsaveri
    marlonsaveri is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2011
    Posts
    110

    Resolved [RESOLVED] How to unlock the sheets while the form is opened?

    Hello,
    When a form is visible in MS Excel, we can not change the worksheet data. How do we "unlock" the spreadsheet so that, although the form is open, we can change your information?
    Reply With Quote Reply With Quote
  2. Jan 12th, 2011, 08:56 AM #2
    Fizziii
    Fizziii is offline
    Addicted Member
    Join Date
    Jul 2008
    Location
    Colorado
    Posts
    193

    Re: How to unlock the sheets while the form is opened?

    Set the "ShowModal" property of the form to false when showing it.
    Reply With Quote Reply With Quote
  3. Jan 12th, 2011, 08:59 AM #3
    marlonsaveri
    marlonsaveri is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2011
    Posts
    110

    Thumbs up Re: How to unlock the sheets while the form is opened?

    Thank you.
    Solved!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width