Runtime Error 1004; Method 'OLEObjects' of object '_Worksheet' failed

Hi everyone! I have this code that auto generate a number (000001) in the text box (textbox is located in the sheet 2) when a button in sheet one is clicked. when a button in sheet2 is clicked (its function is to direct the user in sheet1) it deducts the current generated number by 1, it also requires to continue the generated number its sequel even if the file is closed and saved. Attached herewith is a copy of error and a highlighted part where it says Runtime Error 1004; Method 'OLEObjects' of object '_Worksheet' failed Im using Excel 2007. Thanks a million times. The first code is assigned in the button one in sheet one and the second code is assigned in button 2 in sheet2

Please Login or Register  to view this content.

Hello Adnamut,

I don't see anything wrong with how the code is written. I created a similar setup in a test workbook and it works. Although I am using Office 2010, there is nothing in your code that wouldn't work with 2010.

Have you tried saving the workbook, closing Excel, restarting Excel, and reopening the workbook? Sometimes Excel get overloaded when coding in VBA and what should work, stops working.