Excel file with macros involved really bring in danger?

  • Thread starter Thread starter asika9999
  • Start date Start date
A

asika9999

Recently we designed a online questionair for enterpreneurs basing o
Excel with macros functions.

We workded hard on it and it is almost finished.

However, when we invite enterpreneurs to have a try, it came out
problem.

When they open it online, they are asked to enable macros. As we al
experienced, the computers warn them that macros may bring in viruses,
then they started to fear and refuse to open it.

If they do not use it, our whole work will mean nothing.

I want to persuade these enterpreneurs that enabling macros will not b
as dangerous as they think. But actually I am not very sure of i
either.

Is macros very dangerous for bringing in virus in any case?

Or is there any way I can do to avoid this issue there?

Great thanks in advance.

Asik
 
Asika, this is a common problem. I would write a small paragraph at the point of download that states something like this

This file contains Excel VBA Macros. (this should link to the info below

About Macro

Macros are used to create a set of commands or tasks to be performed automatically. When you have repetitive tasks, you can create a macro that will automatically run a small "program" to perform those tasks for you

Visual Basic for Applications (VBA) is a mini-version of Visual Basic that is installed on your computer as part of the Microsoft Office suite and certain other programs, like Visio. VBA macros allow automation to occur within files, which save the user a lot of additional work

Our workbook contains macros. We certify that the file was scanned by XXX prior to uploading to the web. There is no reason that you should fear the macros in it or any other Office file that contains macros if you maintain a virus scanning program

I don't kow if that helps you or not. I suppose it could be written even more friendly, i.e., stress that if you hadn't used macros it would take them X times longer to complete the information or something like that. I also suggest that you don't allow them to use the workbook WITHOUT allowing macros. Do that by having the file open to a worksheet that explains that macros must be enabled. Then, in the Workbook_open, have the file auto-switch to the worksheet that you want to have focus

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.com
 
Back
Top