sunroyal

  • Thread starter Thread starter sunroyal
  • Start date Start date
S

sunroyal

I am creating an excel wookbook for use on a network. How do I limi
access by the user to only the toolbars I have designed
 
This will hide all the bars, and re-open then on workbook
close. i'm not sure exactly how you'd enable just the one
toolbar (or group of toolbars you need) but this is a
start anyway.
HTH
Kevin M

' hide commandbars
Dim a As Integer

For a = 1 To Application.CommandBars.Count
Application.CommandBars(a).Enabled = False
Next

Application.Visible = True

UserForm1.Hide

End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)

' enable all command bars
Dim a As Integer
For a = 1 To Application.CommandBars.Count
Application.CommandBars(a).Enabled = True
Next

End Sub
 
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

Encrypted Workbook 1
How do I prevent a second personal wookbook from opening up? 3
Find Link 5
Direct to sheet 2
Deleting data but keep formulas/formatting. 3
Header & Footer 2
SHEET SET UP 9
More than 65 thousand rows 2

Back
Top