Only if your tablet runs a full version of Microsoft Office with support for VBA macros.
That means it won’t work on an iPad or an Android tablet, but should work on a Surface Pro. It also won’t work on a Surface RT – the version of Office that runs on the RT doesn’t include VBA macro support.
