View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wifigoo wifigoo is offline
external usenet poster
 
Posts: 4
Default Excel VBA macro to encrypt a Workbook or Spreadsheet

Hello,

I've created a button in a spreadsheet that, when clicked, will encrypt and
compress a Workbook using IZArc's command line tool. Unfortunately, this
requires downloading and installing IZArc software. I would rather use an
Excel built-in function that would encrypt and compress a
Workbook/Spreadsheet thereby avoiding having to download and install IZArc.

Has anyone tried this? Or does anyone know where I may find information to
help me create such a Excel VBA macro?

Many thanks for your help.
Kindest regards,
Olivier.