Workbook_BeforeSave not working.

M

Michelle

This Workbook_BeforeSave code doesn't seem to work! There's a description
field that gets built in the StripOutSpecialCharacters subroutine once the
spreadsheet is saved and its not doing it.
When you do File-SaveAs manually and put it in a work folder when you open
the file the description is not built but if you save from the workfile the
Before_Save kicks in and builds the description in your saved copy.

The the heck is going on?



Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If Not CheckRules Then
MsgBox "Please fix the problems in this worksheet!", vbCritical,
"Errors Were Found"
Cancel = True
Exit Sub
Else
StripOutSpecialCharacters
'GetShortValue
End If
 
G

galimi

Assuming checkRules returns False, we would need to see the code for the
StripOutSpecialCharacters routine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook_BeforeSave 8
I am facing problem while using Public Sub Workbook_BeforeSave(ByValSaveAsUI As Boolean, Cancel As B 3
Private Sub Workbook_BeforeSave 2
Why cant I get the path to the sharepoint library???????? 6
Save not triggering Before_Save event 2
save as cell A1 to to a specific drive 3
Automatically copy with save? 8
using two cell references to make up the save as file name 3

Top