Data Import

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.
 
M

Mike H

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
 
Top