CAN ANY BODY PLEASE HELP

  • Thread starter Thread starter K
  • Start date Start date
K

K

Hi all, I am using excel 2007. in my sheet I got macro command "
Application.Dialogs(xlDialogWorkbookCopy).Show " set on a button.
When users click on this button then "Move or Copy" window appears so
they can Move or Copy the current sheet to some other file. Does any
friend know that what sort of code i add in my macro that when users
click the button and if they try to Move or Copy the current sheet
into non Excel Macro Enabled Workbook then MsgBox should appear
saying
"CONVERT THE DESTINATION FILE INTO EXCEL MACRO ENABLED WORKBOOK
FORMAT" but if they transfer to Excel Macro Enabled Workbook then
macro should do nothing. Please can any friend help.
 
I don't think you can do that.

You'll probably have to script your own variant of Move and Copy. With the
applicable tests and restrictions.
 

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

Macro for all Excel Workbooks to print to PDF 2
excel 2003 vs 2007 menu and sheet issues 3
Buttons re-assigned themselves to the right macro name but in Book 1
PROTECT MACRO IN NEW WORKBOOK 1
Macro Activation 2
Problem in adding macro to ribbon through Add-in 7
Button looses Macro setting when running Macro 1
User can't see Input boxes 3

Back
Top