Excel Forum/Question Answer Template

[CaWingz]

I've looked all over but can't really find what I'm looking for. Basically I'm trying to build a VERY basic forum within Excel. Someone can post a comment, question, etc. Then other employees/Managers can respond.

The problem is that it needs to be saved so that if a manager responds no one can go in and change their response. Or comments cannot be deleted.

Ideas? Thanks in advance

 

[Joyner]

There are a lot of different things you can do, but the problem is, not matter what you do, anyone with a good knowledge of Excel can circumvent it and change anything they want.

But you could do some basic things to cover most cases, but it would most likely need to be automated (use code) to make it easy to use.

 

[CaWingz]

Yea I figured it would need to be with VBA, and yes there are people that could circumvent it. I understand VBA and can get by, but I don't know it well enough to just program it from nothing. So was hoping someone would have a template or an easy way to get it going.

 

[Joyner]

Well we'll see if someone has a decent temple to start with. I did a tool years ago that had protections that was specific to an individual, they had to enter a PIN when prompted and Excel saved that, again anyone really good with Excel could have retrieved it for a Very Hidden worksheet or run the available code to unprotect the worksheets, but for this purpose it did the job.