Hey guys,
Yet another question to hopefully challenge the brain.
I know it is possibly to open an Excel workbook from within access using the Shell() command.
However, I do not want the user to have access to the default menus and toolbars available in Microsoft Excel.
1) Is there a way to programmatically disable these menus and toolbars for that specific workbook file from within Access?
2) If not, is it possible to open the spreadsheet in a window from within Access (showing only the spreadsheet and no menus or toolbars)?
Once again, any help would be greatly appreciated!
Thanks
Yet another question to hopefully challenge the brain.
I know it is possibly to open an Excel workbook from within access using the Shell() command.
However, I do not want the user to have access to the default menus and toolbars available in Microsoft Excel.
1) Is there a way to programmatically disable these menus and toolbars for that specific workbook file from within Access?
2) If not, is it possible to open the spreadsheet in a window from within Access (showing only the spreadsheet and no menus or toolbars)?
Once again, any help would be greatly appreciated!
Thanks