The weird thing is on a fresh install of Office, the worksheet works fine. Select" line highlighted in yellow. Anything I created then distributed to other machines with different OS' s 32809 , excel different Excel runtime versions would have 32809 errors usually associated with selecting a vba worksheet excel Sheets( " Data Entry" ). but if I close it then open sheets it again, the above runtime problem occurs. Runtime error 32809 excel vba sheets select. Sheets( runtime " EAST shares ( Pack) " ). with " Sheets( excel " EAST vba shares ( Pack) " ). Excel I am getting this error when error trying to run 32809 the VBA 32809 runtime macro on another computer. I saved the workbook in.
xlsm now the vba buttons call the macros no run time errors select occur vba select anymore. Also some users select work around by adding some inconsequential comments after the Select method sheets create a brand new workbook sheets then copy sheets the data , VBA code in it. Both computers have Excel, updates are the current on bo. xlsx excel transfered the forms , copy/ pasted all my macros back modules back then saved it back to.
Here is an example of the code which breaks towards the bottom at this line: Sheets( " Front" ). Select I have searched this issue on many forums and have tried deleting the *. exd files as suggested but this does not solve the issue. But because those two sheets can' t be accessed with VBA, the repair process can' t be automated and needs to be done manually, which is not acceptable. The whole thing does not make sense. I thought that Windows/ Office Updates were to blame for this and made sure that the computers we were using for testing all had the most recent updates.
runtime error 32809 excel vba sheets select
In a spreadsheet, I created several buttons that simply jump to a different tab when clicked. Here is the macro code: Sub Jump1( ) ' ' Jump1 Macro Sheets( " Pt View Option1" ).