+ Reply to Thread
Results 1 to 5 of 5

All Sheet level function fail (Excel is partially stuck)

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    All Sheet level function fail (Excel is partially stuck)

    Hi,

    I am coming across an error during execution of a normal macro even, my Excel stops responding to functions such as it does not allow copy / paste, find function (Ctrl + F) says not found (while the value to be searched is clearly there). Meanwhile the right click contextual menu is working . selected cell is not identified (no outlines appear around the activecell).

    I do not have any clear clue but looks like something related to user32.dll which I used on some form to make them transparent/borderless.
    I am using a famous code snip to make one of my userform transparent that uses the user32.dll.


    the reason I suspect user32.dll is because if I comment those lines of code then the error is not there.
    If anyone else has also confronted with the same and found a solution ,please share.

    Help would be greatly appreciated in this regard

    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: All Sheet level function fail (Excel is partially stuck)

    Please share the code which causes the issue.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: All Sheet level function fail (Excel is partially stuck)

    Thanks Oily for the review

    I am using the following preloader in my project which call user32.dll and when sometime action is completed it block any input to excel worksheet panel and all of the worksheet class functions failed. Project link: https://www.spreadsheet1.com/flat-an...for-excel.html

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: All Sheet level function fail (Excel is partially stuck)

    All other parts of the application like Ribbon / Scrollbars etc work fine. The only affected area is the worksheet range (cells of the file).

  5. #5
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: All Sheet level function fail (Excel is partially stuck)

    Anyone please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel sheet stuck in read only
    By Sionach in forum Excel General
    Replies: 1
    Last Post: 02-17-2017, 07:43 PM
  2. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  3. 6 level dependent listing for data validation to another sheet in excel
    By Ennesai in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2013, 05:03 AM
  4. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  5. [SOLVED] IFERROR function with Hour function Fail
    By Kram222 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2012, 12:25 AM
  6. Simple pass fail function in excel
    By slider203 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2011, 04:49 PM
  7. sheet level range names in excel 2003?
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2011, 05:02 AM

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