Posts by imported_Anonymous

A limitation with Excel is you can only unhide one worksheet at a time. Below is some code that allows the user to unhide as many worksheets as they choose, at once.

Create a ListBox (Call it ListBox1) and a Command Button (Call it CommandButton1) in an Excel Worksheet.
Make sure that the MultiSelect Feature is selected on the ListBox. To choose the multiselect feature, doubleclick on the list box in design mode, choose Categorized, and then under MultiSelect choose the 3rd option, fmMultiSelectExtended.

Go to the VBA Code Editor on the worksheet that contains the listbox and command button, and add the following code:

Private Sub CommandButton1_Click()

Dim i As Integer
i = 0

Dim x As Integer
x = ListBox1.ListCount - 1

For i = 0 To x
If ListBox1.Selected(i) = True Then
Worksheets(i + 1).Visible = False
End If
Next i

End Sub

Now just choose which worksheets you want to hide and hit the button.

See, this is what happens when Dave does a bit of maintenance on Christmas Day after too much turkey. :tumble: :cheers: :barf:

WTG Tom :dance2:

Richie,
Thanks for your help. Sorry, I have no idea how to post an Excel sheet on the internet.

My main problem here is that I'm using modular math, with the alphabet as the plain text. We're using a (mod 26) in addition to an affine cipher, that is a multiplicative as well as an additive cipher.

The keys that I'm using are

multiplicative=3
additive=7

Thanks again for your help.
-Jim

Hello,
I have been assigned to compose an Excel sheet in which a message can be entered and the sheet will automatically encipher the message. It's basically cryptography. But to further demonstrate the process (this will be a presentation) the sheet also needs to be able to have a section in which an encrypted message can be entered and it will be deciphered.

Basically, I have to make a code that will go forwards into encryption and then backwards out of encryption.

My difficulties arise not from the encryption, but the decryption. Try as I might, I have had no luck getting there, so any help will be greatly appreciate. Thanks.

Is there any way to store a randomly generated number in a cell?
and is there a way to add to this number?

can you help with a series question regarding excel 97

Yes, no more anonymous postings!
:banana:
Hey, how'd I do that?

he heh.... what? and then play guess the poster :biggrin:

Jack,

Cheers mate.... you know it's nothing personal - you have nothing to apologise for!! :biggrin:

oops, it seems I forgot to log in :spin:

your buddy Will.... (anon)

WillR

We here promote teh family thing on OzGrid, and as such im happy how thigs are, i get your points, and they are noted. Let me know if its an issue and i will do all i can. But i dont wont to loose the open friendly no hidden secrets way i / we all are. This is important to me

Jack

How do you form a productivity sheet based on the hours somebody works? However, it needs to be able to automatically work into each month on its own.

You gotta be good to solve this one.

I have an excel spreadsheet that uses DDE. In a two cells, it grabs two current numbers from a datataker (real-time peice of monitoring hardware). This updates everytime new data is available.

Thing is, I want to keep the old data in two columns. All of this will get displayed in realtime on charts. I believe I need some VBA scripting to achieve this. It probably has to poll intermittently (in the background) to see if the values have changed, then append them to the columns.

Any VBA guru's out there like to waste some time helping me out with this one?

Is there any way that i can convert an excel program which also has vba code into html or java so i use it on the web?:(

I am totally stumped...

I have hundreds of excel (XP) workbooks that contain identical fields and information types. For example, let's say in each and every workbook cell A2 contains the text name; cell B4 contains a dollar amount; cell D6 contains a date;etc. I need to consolidate all of the data from all of these workbooks into a single Access table/db. This table/db would have fields for the text name, the dollar amount and the date and each row would contain the specific data from each workbook. Additionally, I need this table to update itself automatically when new workbooks are created.

Am I dreaming? Can this even be done? I don't even know in which direction to begin my search for tools/commands/formulae. Any help you could provide would be greatly appreciated!!!

q-gms
indicators master
q-clinical

or something similar, from memory

===============

my login error is that it doesn't recognise my username / password

neither have changed, unless someone else has used it without me knowing

Why can't I log in ?

my password has not changed.

Chris Davison.

A whole three-day weekend in which to excel.
... or is that Excel?

Is there a way to make the chart point into a letter e.g. if I want to plot (23, 44) for person AD and (27,48) for person BF on a chart and have the points come up as AD and BF on the chartr instead of dots etc?

Thanks, [email protected]

I want to submit a par o fresults for AA and get the point to display on the chart as 'AA' instead of a shape.
E.g. AA, 65, 35
BB 45, 27as the points

|
|
| AA
|
| BB
|___________________

Any help please would be most appreciated.