VBA & Macro Problems

How to Create a Secret Voting System in Excel Online Without VBA

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

Question details

The user wants an online Excel voting sheet where voters can select a candidate directly or use a random-entry cell while keeping the selection method confidential.

How to Create a Secret Voting System in Excel Online Without VBA
Product
Microsoft Excel Online and Microsoft Forms
Device & OS
not provided
Scenario
Running a confidential online election or poll from a spreadsheet.
Observed behavior
VBA macros may not run reliably in Excel for the web, so a macro-based voting sheet is not dependable for online voters.
Before you start

Confirm whether voters will open the file in a web browser or in a desktop app. If the ballot must be online, avoid relying on VBA macros and use a response-collection tool such as Microsoft Forms.

Solution 1Recommended

Use Microsoft Forms to create a confidential online ballot

Best when voters must vote from different devices and the voting method must remain hidden.

VBA macros do not run reliably in Excel for the web, and any formula or macro in the workbook can expose the voting logic. Microsoft Forms collects responses separately, so voters only see the choice question.

1
Open Microsoft Forms

Go to forms.microsoft.com in a web browser and sign in with your Microsoft account.

2
Create a new form

Click New Form, enter a title such as “Secret Vote,” and click Add new to insert a Choice question.

3
List the candidates

Type each candidate as an option. If you need a random-entry or write-in option, use a separate text question and do not link it to spreadsheet formulas.

4
Share the response link

Click Collect responses, copy the link, and share it only with the intended voters.

5
Review responses securely

Open the Responses tab to view aggregated results or export them to Excel if needed.

Use Microsoft Forms to create a confidential online ballot
Why this is confidential: Voters do not see the underlying spreadsheet, and the voting logic remains inside Microsoft Forms instead of editable workbook cells.
Free Microsoft Office alternative

Use WPS Office as a Free Spreadsheet Alternative for Offline Voting Workbooks

For everyday spreadsheet tasks, WPS Office is a free, lightweight, easy-to-use alternative that opens .xlsx files, keeps familiar menus, and can help with offline or internal voting sheets while Microsoft Forms handles remote secret ballots.

  1. 1. Download WPS Office: Go to wps.com and click Download WPS Office Free, then install the desktop app.
  2. 2. Open an existing Excel workbook: Launch WPS Spreadsheets and open the .xlsx file you already use.
  3. 3. Set up a simple local voting sheet: Create a candidate list, apply Data Validation for direct selection, and protect the sheet from Review > Protect Sheet.
Compatible with Microsoft Excel .xlsx files and forms export workbooksFree spreadsheet app with a familiar Office-style interfaceLets you open and protect local voting workbooks without extra costLightweight installation and easy migration from Microsoft Excel
microsoft office alternative - wps office

Frequently Asked Questions

Can I use a VBA macro in Excel Online to randomize a candidate choice?

No. Excel for the web does not support VBA macros, so the macro will not run for online voters. Use Microsoft Forms for a secret online ballot, or use a desktop Excel/VBA workbook in a controlled environment.

How do I stop voters from seeing which candidate was selected by a random formula?

Do not put the random formula in the same sheet that voters use. In Microsoft Forms, use a Choice question so responses are collected outside the workbook. In WPS Spreadsheet, hide and protect the formula cells with Review > Protect Sheet.

Can I use WPS Spreadsheet instead of Excel Online for the voting sheet?

Yes, you can use WPS Spreadsheet for offline or in-person voting. Open the workbook, set up Data Validation for candidate selection, and protect the sheet. However, it does not provide a secret online response link.

How do I export Microsoft Forms responses to Excel?

In Microsoft Forms, open the Responses tab and click Open in Excel to download an .xlsx workbook that contains the collected responses.

Does WPS Office support VBA macros in desktop spreadsheets?

WPS Spreadsheets supports VBA macros in the desktop version, but macro compatibility may vary. For online secret ballots, Microsoft Forms is still the recommended method.