Search results for query: *

>If you want to have macros you can use but others cannot then create an addin and place the macros there. Place this addin only on your computer in the xlstart folder that way you can access it from your computer but others cannot. This would work, but it would force this workbook to open...

>ActiveWorkbook returns the workbook >A-ha! I understand now. The easiest way to get the name of >the workbook is - as combo says - ActiveWorkbook.name as the >button can only have been pressed in the active workbook. You are both right - that did work. I must have screwed something up...

I guess I was hoping there may be some property that tells what the last active workbook was. Sort of like HTTP_REFERER does for web pages. t

>If macros are disabled, how could a button in your "macro >free workbook" call ANYTHING??? You can link a button in a macro free workbook (.xls in 2007) to a macro in macro enabled workbook (.xlsm in 2007). Right-click on the button and choose 'assign macro'. The security stuff then happens...

I wondering if there is a way to have a button in a macro free workbook call a macro in another workbook AND for the macro to know the filename of the workbook with the button. Basically, I need to have a macro free workbook that is shared and edited by different people. I don't want them to...

Thank You!!! t

Is is possible to use an SQL statement to reference tables in databases residing on other computers? I am hoping to avoid linking tables - but it may not be possible. TIA, t