Macro on Personnel.XLSB gets deleted...Need help

[balaji3081]

Below are the two Macros I am trying to save on Personal.XLSB, its runs fine, once I close the excel application, and reopen, the macro is gone.....Am I doing something wrong, this is the first time I am working on Personal.xlsb.....

1) The code below is to get the number in the selected cell in comma with no decimal places format

Sub Numformat()

'Keyboard Shortcut: Ctrl+q
Selection.NumberFormat = "#,##0"
End Sub


2) This one is the best , this changes the pivot view to Classic -

Sub Classic_Pivot()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
pt.InGridDropZones = True
pt.RowAxisLayout xlTabularRow
Next pt
End Sub


Regards,
Bala

 

[Sam Mathai Chacko]

Are you sure the Personal.XLSB file isn't getting touched by some other macro? If not, can you try recording a macro by selecting your Personal.xlsb workbook, and before you close excel application, check if it is asking to save the personal.xlsb project?

 

[Smallman]

Hi

There is usually one culprit in this situation. In peoples haste to close XL and get the hell out of dodge they click through alert messages. One of these Alerts is and this is just from memory.

"You have made changes to the Personal macro workbook. Would you like to save these changes."

If you click 'No' in haste, changes will be lost. If you click 'Yes', changes will be saved. As Sam suggested open XL record a macro to the Personal.xls now close xl and click 'Yes' with the question is Asked. Now reopen XL. I would put a small forturne on that maco being in the Personal Macro workbook.

Take care

Smallman