Sign in to follow this  
Guest Paulo de Freitas

Macro

Recommended Posts

Guest Paulo de Freitas

Bom dia amigos,

Como faço para que uma macro seja executada todas as vezes que a planilha for aberta a partir de 01/06/2007?

Gostaria também de saber se é possivel que caso a planilha seja aberta sem ativar macros ela feche automaticamente.

Muito obrigado

Share this post


Link to post
Share on other sites
Guest gdonizett

Private Sub Workbook_Open()

If Date > #6/1/2007# Then

'INCLUIR AQUI SUA ROTINA

End If

End Sub

BOA SORTE

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this