+ 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 XP to Office 2016
    Posts
    1,683

    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 Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,217

    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 XP to Office 2016
    Posts
    1,683

    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 XP to Office 2016
    Posts
    1,683

    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 XP to Office 2016
    Posts
    1,683

    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)

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