July 02, 2020, 05:02:39 am
News: If someone gives you assistance give them a Good Star
Pages: [1]   Go Down
Author Topic: Jsut me or is this whacked, more Excel 2010 weirdness ....  (Read 4265 times)

Stars: +0/-0
Offline Offline

Posts: 1845

« on: March 04, 2012, 09:58:30 pm »

Just in the process of deploying a spreadsheet and of course am hiding the working sheets. Unfort this causes vba error meesages  console

The work around is to unhide as the vba tramples through the sheet, but that seems like a kludge, anyone got a better approach?

[size=] - Movie Reviews, Discussion, and in due course articles and stuff and that [/size]

Jason Reed

Stars: +4/-0
Offline Offline

Gender: Male
Posts: 4536

Pure Evil Administrator

« Reply #1 on: March 05, 2012, 10:10:06 am »

The questions I would have are
1) why do you need vba? Can what you are doing not be done with the standard functions in a spread sheet?
2) is the error appearing because the sheets are not visible? As in the vba needs the sheets to be accessible to perform actions on them?

-- signature --

Pages: [1]   Go Up
Jump to: