Data Import

  • Thread starter Thread starter Shaun
  • Start date Start date
S

Shaun

Is it possible to remove or disable the data tab. The reason for this is it
can be used to pull data from a sql server on the domain if it's connection
is set up for mixed mode.
 
Hi,

Do you mean the 'Data' menu? If so

Application.CommandBars("Worksheet Menu Bar").Controls("&Data").Enabled =
False

remembering of course to re-enable it at some point.

Mike
 
You must log in or register to reply here.

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

Create Macro to pull data from a warehouse management system? 1
How to pull only dates within a requested dynamic range 3
Run Macro when click on different tab in Excel 3
import data into SQL Server from Excel 1
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Data Import into Excel 3
="'"&F1&"'," Excel errors in one spreadsheet but not other one? 1
How can I find external data query name 3

Back
Top