#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Hi Excel

Hi I have a file *.xls when the people open this i want to desapear in the
menu "Save As" How I Can do? Marcelo..Buenos Aires Argentina....

Tengo una planilla *.xls y cuando la abren quiero que del menu desaparezca
el "Guardar Como" para que no me hagan copias ok?? No se si fui claro..

Marcelo..Buenos Aires Argentina....


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Hi Excel

Pon lo siguiente en el modulo ThisWorkbook en el editor del
VBA:

Private Sub Workbook_Activate()
With Application.CommandBars("Worksheet Menu Bar")
.Controls("File").Controls("Save As...").Enabled =
False
End With
End Sub

Private Sub Workbook_Deactivate()
With Application.CommandBars("Worksheet Menu Bar")
.Controls("File").Controls("Save As...").Enabled =
True
End With
End Sub

--
Saludos,

David Canales


"Marcelo Pregliasco" wrote
in message ...
Hi I have a file *.xls when the people open this i want to

desapear in the
menu "Save As" How I Can do? Marcelo..Buenos Aires

Argentina....

Tengo una planilla *.xls y cuando la abren quiero que del

menu desaparezca
el "Guardar Como" para que no me hagan copias ok?? No se

si fui claro..

Marcelo..Buenos Aires Argentina....




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"