WebYour Personal.xlsb file is stored in a system startup folder. If you want to share your macros with someone else, you can copy Personal.xlsb to the startup folder on other computers, or copy some or all of its macros to the Personal.xlsb file on other computers. In Finder select Go, then hold down the Option key, and select Library. WebFeb 14, 2013 · Hi Cut2, You need to unhide your PERSONAL.XLSB file to edit or delete macros saved to it. To do this open a blank work sheet and then go View>Unhide and …
[6 Fixes] Cannot Edit A Macro On A Hidden Workbook - Excel File …
WebMar 14, 2024 · To create it, you will need to recorded at least one macro. Once to Personal.xlsb file is produced, i can add any other macros in it by using an VB Editor. Where is Personal Macro Workbook? The Personal.xlsb file is storing in the XLSTART folder in to following locations. WebJun 26, 2024 · In the View tab, click Unhide and then Personal.xlsb If the unhide is greyed out then run one of the Personal macros and it should then be available to use 13 people found this reply helpful · Was this reply helpful? Yes No Answer EL EliseM_456 Independent Advisor Replied on June 26, 2024 Report abuse dr kovacs istvan obuda
How to Remove Macro from Personal.xlsb Files? Solved - BitRecover
WebClick on the Macros button. This will open the Macro dialogue box where you can see all the macros in the workbook. In the ‘Macros in’ drop-down, make sure ‘This Workbook’ is selected. Select the macro name that you want to delete from the … WebOct 6, 2015 · make the personal.xlsb the active workbook. Then go to the view tab and click the hide button. Then exit excel and indicate that you want to save changes to the Personal.xlsb when prompted. -- Regards, Tom Ogilvy Tom Ogilvy 125 people found this reply helpful · Was this reply helpful? Yes No Replies (1) WebOct 25, 2010 · How do I delete Personal.xlsb? I did try to hide it but the ribbon bar and blue screen still remain. I tried to delete from XLStart but nothing was in that file. Obvisously I … dr. kovač mohar