Menu

VBAProject

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

See answer to your other post

--
Don Guillett
SalesAid Software

"Andy" wrote in message
...
Hi

I am running the following VBAProject in a Module

Option Explicit

Public Function PromptPayment()
MsgBox "Please issue Prompt Payment Letter and input
relevant information to PP spreadsheet"

End Function

This works well when I put the following formula in a
number of cells

=IF((F4-E4)=15,PromptPayment()+F4-E4,F4-E4)

The problem I have is that the data that I have saved
cannot be deleted for Audit requirements so when I open
the workbook after a close down, the message box appears
(ref above VBA runs) before it opens and you have to
click ok.
The only way I can get rid of this is by deleting the
cell with the more than 15 days.
However as explained above, I need this information to be
keep for Audit.
Can anyone please help?

PS I am using my works PC that's why it comes up
anonymous-My user name is Monty

Thanks
Monty

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement